package com.mhc.suzuki.dal.query;


import com.subaru.common.query.BaseCriteria;
import com.subaru.common.query.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public class LoanInfoQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public LoanInfoQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table pcl_loan_info
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andLoanInfoIdIsNull() {
            addCriterion("loan_info_id is null");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdIsNotNull() {
            addCriterion("loan_info_id is not null");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdEqualTo(Long value) {
            addCriterion("loan_info_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdNotEqualTo(Long value) {
            addCriterion("loan_info_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anLoanInfoIdGreaterThan(Long value) {
            addCriterion("loan_info_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdGreaterThanOrEqualTo(Long value) {
            addCriterion("loan_info_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdLessThan(Long value) {
            addCriterion("loan_info_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdLessThanOrEqualTo(Long value) {
            addCriterion("loan_info_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdIn(List<Long> values) {
            addCriterion("loan_info_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdNotIn(List<Long> values) {
            addCriterion("loan_info_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdBetween(Long value1, Long value2) {
            addCriterion("loan_info_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdNotBetween(Long value1, Long value2) {
            addCriterion("loan_info_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDate value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDate value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDate value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDate value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDate> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDate> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDate value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDate value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDate value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDate value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDate> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDate> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdIsNull() {
            addCriterion("biz_type_id is null");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdIsNotNull() {
            addCriterion("biz_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdEqualTo(Long value) {
            addCriterion("biz_type_id =", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdNotEqualTo(Long value) {
            addCriterion("biz_type_id <>", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdGreaterThan(Long value) {
            addCriterion("biz_type_id >", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("biz_type_id >=", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdLessThan(Long value) {
            addCriterion("biz_type_id <", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdLessThanOrEqualTo(Long value) {
            addCriterion("biz_type_id <=", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdLike(Long value) {
            addCriterion("biz_type_id like", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdNotLike(Long value) {
            addCriterion("biz_type_id not like", value, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdIn(List<Long> values) {
            addCriterion("biz_type_id in", values, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdNotIn(List<Long> values) {
            addCriterion("biz_type_id not in", values, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdBetween(Long value1, Long value2) {
            addCriterion("biz_type_id between", value1, value2, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeIdNotBetween(Long value1, Long value2) {
            addCriterion("biz_type_id not between", value1, value2, "bizTypeId");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameIsNull() {
            addCriterion("biz_type_name is null");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameIsNotNull() {
            addCriterion("biz_type_name is not null");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameEqualTo(String value) {
            addCriterion("biz_type_name =", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameNotEqualTo(String value) {
            addCriterion("biz_type_name <>", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameGreaterThan(String value) {
            addCriterion("biz_type_name >", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("biz_type_name >=", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameLessThan(String value) {
            addCriterion("biz_type_name <", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameLessThanOrEqualTo(String value) {
            addCriterion("biz_type_name <=", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameLike(String value) {
            addCriterion("biz_type_name like", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameNotLike(String value) {
            addCriterion("biz_type_name not like", value, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameIn(List<String> values) {
            addCriterion("biz_type_name in", values, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameNotIn(List<String> values) {
            addCriterion("biz_type_name not in", values, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameBetween(String value1, String value2) {
            addCriterion("biz_type_name between", value1, value2, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBizTypeNameNotBetween(String value1, String value2) {
            addCriterion("biz_type_name not between", value1, value2, "bizTypeName");
            return (Criteria) this;
        }

        public Criteria andBankIdIsNull() {
            addCriterion("bank_id is null");
            return (Criteria) this;
        }

        public Criteria andBankIdIsNotNull() {
            addCriterion("bank_id is not null");
            return (Criteria) this;
        }

        public Criteria andBankIdEqualTo(Long value) {
            addCriterion("bank_id =", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotEqualTo(Long value) {
            addCriterion("bank_id <>", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdGreaterThan(Long value) {
            addCriterion("bank_id >", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdGreaterThanOrEqualTo(Long value) {
            addCriterion("bank_id >=", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLessThan(Long value) {
            addCriterion("bank_id <", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLessThanOrEqualTo(Long value) {
            addCriterion("bank_id <=", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdLike(Long value) {
            addCriterion("bank_id like", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotLike(Long value) {
            addCriterion("bank_id not like", value, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdIn(List<Long> values) {
            addCriterion("bank_id in", values, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotIn(List<Long> values) {
            addCriterion("bank_id not in", values, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdBetween(Long value1, Long value2) {
            addCriterion("bank_id between", value1, value2, "bankId");
            return (Criteria) this;
        }

        public Criteria andBankIdNotBetween(Long value1, Long value2) {
            addCriterion("bank_id not between", value1, value2, "bankId");
            return (Criteria) this;
        }

        public Criteria andPeriodIsNull() {
            addCriterion("period is null");
            return (Criteria) this;
        }

        public Criteria andPeriodIsNotNull() {
            addCriterion("period is not null");
            return (Criteria) this;
        }

        public Criteria andPeriodEqualTo(Integer value) {
            addCriterion("period =", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodNotEqualTo(Integer value) {
            addCriterion("period <>", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodGreaterThan(Integer value) {
            addCriterion("period >", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodGreaterThanOrEqualTo(Integer value) {
            addCriterion("period >=", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodLessThan(Integer value) {
            addCriterion("period <", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodLessThanOrEqualTo(Integer value) {
            addCriterion("period <=", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodLike(Integer value) {
            addCriterion("period like", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodNotLike(Integer value) {
            addCriterion("period not like", value, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodIn(List<Integer> values) {
            addCriterion("period in", values, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodNotIn(List<Integer> values) {
            addCriterion("period not in", values, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodBetween(Integer value1, Integer value2) {
            addCriterion("period between", value1, value2, "period");
            return (Criteria) this;
        }

        public Criteria andPeriodNotBetween(Integer value1, Integer value2) {
            addCriterion("period not between", value1, value2, "period");
            return (Criteria) this;
        }

        public Criteria andBillingAmountIsNull() {
            addCriterion("billing_amount is null");
            return (Criteria) this;
        }

        public Criteria andBillingAmountIsNotNull() {
            addCriterion("billing_amount is not null");
            return (Criteria) this;
        }

        public Criteria andBillingAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("billing_amount =", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("billing_amount <>", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("billing_amount >", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("billing_amount >=", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountLessThan(java.math.BigDecimal value) {
            addCriterion("billing_amount <", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("billing_amount <=", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountLike(java.math.BigDecimal value) {
            addCriterion("billing_amount like", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountNotLike(java.math.BigDecimal value) {
            addCriterion("billing_amount not like", value, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("billing_amount in", values, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("billing_amount not in", values, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("billing_amount between", value1, value2, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andBillingAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("billing_amount not between", value1, value2, "billingAmount");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateIsNull() {
            addCriterion("company_charge_rate is null");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateIsNotNull() {
            addCriterion("company_charge_rate is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateEqualTo(java.math.BigDecimal value) {
            addCriterion("company_charge_rate =", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateNotEqualTo(java.math.BigDecimal value) {
            addCriterion("company_charge_rate <>", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateGreaterThan(java.math.BigDecimal value) {
            addCriterion("company_charge_rate >", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("company_charge_rate >=", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateLessThan(java.math.BigDecimal value) {
            addCriterion("company_charge_rate <", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("company_charge_rate <=", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateLike(java.math.BigDecimal value) {
            addCriterion("company_charge_rate like", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateNotLike(java.math.BigDecimal value) {
            addCriterion("company_charge_rate not like", value, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateIn(List<java.math.BigDecimal> values) {
            addCriterion("company_charge_rate in", values, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateNotIn(List<java.math.BigDecimal> values) {
            addCriterion("company_charge_rate not in", values, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("company_charge_rate between", value1, value2, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andCompanyChargeRateNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("company_charge_rate not between", value1, value2, "companyChargeRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateIsNull() {
            addCriterion("execution_rate is null");
            return (Criteria) this;
        }

        public Criteria andExecutionRateIsNotNull() {
            addCriterion("execution_rate is not null");
            return (Criteria) this;
        }

        public Criteria andExecutionRateEqualTo(java.math.BigDecimal value) {
            addCriterion("execution_rate =", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateNotEqualTo(java.math.BigDecimal value) {
            addCriterion("execution_rate <>", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateGreaterThan(java.math.BigDecimal value) {
            addCriterion("execution_rate >", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("execution_rate >=", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateLessThan(java.math.BigDecimal value) {
            addCriterion("execution_rate <", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("execution_rate <=", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateLike(java.math.BigDecimal value) {
            addCriterion("execution_rate like", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateNotLike(java.math.BigDecimal value) {
            addCriterion("execution_rate not like", value, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateIn(List<java.math.BigDecimal> values) {
            addCriterion("execution_rate in", values, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateNotIn(List<java.math.BigDecimal> values) {
            addCriterion("execution_rate not in", values, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("execution_rate between", value1, value2, "executionRate");
            return (Criteria) this;
        }

        public Criteria andExecutionRateNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("execution_rate not between", value1, value2, "executionRate");
            return (Criteria) this;
        }

        public Criteria andLoanAmountIsNull() {
            addCriterion("loan_amount is null");
            return (Criteria) this;
        }

        public Criteria andLoanAmountIsNotNull() {
            addCriterion("loan_amount is not null");
            return (Criteria) this;
        }

        public Criteria andLoanAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_amount =", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_amount <>", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("loan_amount >", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_amount >=", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountLessThan(java.math.BigDecimal value) {
            addCriterion("loan_amount <", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_amount <=", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountLike(java.math.BigDecimal value) {
            addCriterion("loan_amount like", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountNotLike(java.math.BigDecimal value) {
            addCriterion("loan_amount not like", value, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("loan_amount in", values, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("loan_amount not in", values, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("loan_amount between", value1, value2, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andLoanAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("loan_amount not between", value1, value2, "loanAmount");
            return (Criteria) this;
        }

        public Criteria andDownPaymentIsNull() {
            addCriterion("down_payment is null");
            return (Criteria) this;
        }

        public Criteria andDownPaymentIsNotNull() {
            addCriterion("down_payment is not null");
            return (Criteria) this;
        }

        public Criteria andDownPaymentEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment =", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentNotEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment <>", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentGreaterThan(java.math.BigDecimal value) {
            addCriterion("down_payment >", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment >=", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentLessThan(java.math.BigDecimal value) {
            addCriterion("down_payment <", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment <=", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentLike(java.math.BigDecimal value) {
            addCriterion("down_payment like", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentNotLike(java.math.BigDecimal value) {
            addCriterion("down_payment not like", value, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentIn(List<java.math.BigDecimal> values) {
            addCriterion("down_payment in", values, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentNotIn(List<java.math.BigDecimal> values) {
            addCriterion("down_payment not in", values, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("down_payment between", value1, value2, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("down_payment not between", value1, value2, "downPayment");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateIsNull() {
            addCriterion("down_payment_rate is null");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateIsNotNull() {
            addCriterion("down_payment_rate is not null");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment_rate =", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateNotEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment_rate <>", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateGreaterThan(java.math.BigDecimal value) {
            addCriterion("down_payment_rate >", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment_rate >=", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateLessThan(java.math.BigDecimal value) {
            addCriterion("down_payment_rate <", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("down_payment_rate <=", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateLike(java.math.BigDecimal value) {
            addCriterion("down_payment_rate like", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateNotLike(java.math.BigDecimal value) {
            addCriterion("down_payment_rate not like", value, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateIn(List<java.math.BigDecimal> values) {
            addCriterion("down_payment_rate in", values, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateNotIn(List<java.math.BigDecimal> values) {
            addCriterion("down_payment_rate not in", values, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("down_payment_rate between", value1, value2, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andDownPaymentRateNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("down_payment_rate not between", value1, value2, "downPaymentRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateIsNull() {
            addCriterion("loan_rate is null");
            return (Criteria) this;
        }

        public Criteria andLoanRateIsNotNull() {
            addCriterion("loan_rate is not null");
            return (Criteria) this;
        }

        public Criteria andLoanRateEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_rate =", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_rate <>", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateGreaterThan(java.math.BigDecimal value) {
            addCriterion("loan_rate >", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_rate >=", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateLessThan(java.math.BigDecimal value) {
            addCriterion("loan_rate <", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("loan_rate <=", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateLike(java.math.BigDecimal value) {
            addCriterion("loan_rate like", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotLike(java.math.BigDecimal value) {
            addCriterion("loan_rate not like", value, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateIn(List<java.math.BigDecimal> values) {
            addCriterion("loan_rate in", values, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotIn(List<java.math.BigDecimal> values) {
            addCriterion("loan_rate not in", values, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("loan_rate between", value1, value2, "loanRate");
            return (Criteria) this;
        }

        public Criteria andLoanRateNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("loan_rate not between", value1, value2, "loanRate");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentIsNull() {
            addCriterion("monthly_payment is null");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentIsNotNull() {
            addCriterion("monthly_payment is not null");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentEqualTo(java.math.BigDecimal value) {
            addCriterion("monthly_payment =", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentNotEqualTo(java.math.BigDecimal value) {
            addCriterion("monthly_payment <>", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentGreaterThan(java.math.BigDecimal value) {
            addCriterion("monthly_payment >", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("monthly_payment >=", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentLessThan(java.math.BigDecimal value) {
            addCriterion("monthly_payment <", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("monthly_payment <=", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentLike(java.math.BigDecimal value) {
            addCriterion("monthly_payment like", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentNotLike(java.math.BigDecimal value) {
            addCriterion("monthly_payment not like", value, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentIn(List<java.math.BigDecimal> values) {
            addCriterion("monthly_payment in", values, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentNotIn(List<java.math.BigDecimal> values) {
            addCriterion("monthly_payment not in", values, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("monthly_payment between", value1, value2, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andMonthlyPaymentNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("monthly_payment not between", value1, value2, "monthlyPayment");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateIsNull() {
            addCriterion("bank_loan_date is null");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateIsNotNull() {
            addCriterion("bank_loan_date is not null");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateEqualTo(LocalDateTime value) {
            addCriterion("bank_loan_date =", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateNotEqualTo(LocalDateTime value) {
            addCriterion("bank_loan_date <>", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateGreaterThan(LocalDateTime value) {
            addCriterion("bank_loan_date >", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("bank_loan_date >=", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateLessThan(LocalDateTime value) {
            addCriterion("bank_loan_date <", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("bank_loan_date <=", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateLike(LocalDateTime value) {
            addCriterion("bank_loan_date like", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateNotLike(LocalDateTime value) {
            addCriterion("bank_loan_date not like", value, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateIn(List<LocalDateTime> values) {
            addCriterion("bank_loan_date in", values, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateNotIn(List<LocalDateTime> values) {
            addCriterion("bank_loan_date not in", values, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("bank_loan_date between", value1, value2, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("bank_loan_date not between", value1, value2, "bankLoanDate");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountIsNull() {
            addCriterion("bank_loan_amount is null");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountIsNotNull() {
            addCriterion("bank_loan_amount is not null");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount =", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount <>", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount >", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount >=", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountLessThan(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount <", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount <=", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountLike(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount like", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountNotLike(java.math.BigDecimal value) {
            addCriterion("bank_loan_amount not like", value, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("bank_loan_amount in", values, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("bank_loan_amount not in", values, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("bank_loan_amount between", value1, value2, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andBankLoanAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("bank_loan_amount not between", value1, value2, "bankLoanAmount");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdIsNull() {
            addCriterion("payee_dealer_id is null");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdIsNotNull() {
            addCriterion("payee_dealer_id is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdEqualTo(Long value) {
            addCriterion("payee_dealer_id =", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdNotEqualTo(Long value) {
            addCriterion("payee_dealer_id <>", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdGreaterThan(Long value) {
            addCriterion("payee_dealer_id >", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("payee_dealer_id >=", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdLessThan(Long value) {
            addCriterion("payee_dealer_id <", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdLessThanOrEqualTo(Long value) {
            addCriterion("payee_dealer_id <=", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdLike(Long value) {
            addCriterion("payee_dealer_id like", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdNotLike(Long value) {
            addCriterion("payee_dealer_id not like", value, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdIn(List<Long> values) {
            addCriterion("payee_dealer_id in", values, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdNotIn(List<Long> values) {
            addCriterion("payee_dealer_id not in", values, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdBetween(Long value1, Long value2) {
            addCriterion("payee_dealer_id between", value1, value2, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerIdNotBetween(Long value1, Long value2) {
            addCriterion("payee_dealer_id not between", value1, value2, "payeeDealerId");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameIsNull() {
            addCriterion("payee_dealer_name is null");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameIsNotNull() {
            addCriterion("payee_dealer_name is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameEqualTo(String value) {
            addCriterion("payee_dealer_name =", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameNotEqualTo(String value) {
            addCriterion("payee_dealer_name <>", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameGreaterThan(String value) {
            addCriterion("payee_dealer_name >", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameGreaterThanOrEqualTo(String value) {
            addCriterion("payee_dealer_name >=", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameLessThan(String value) {
            addCriterion("payee_dealer_name <", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameLessThanOrEqualTo(String value) {
            addCriterion("payee_dealer_name <=", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameLike(String value) {
            addCriterion("payee_dealer_name like", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameNotLike(String value) {
            addCriterion("payee_dealer_name not like", value, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameIn(List<String> values) {
            addCriterion("payee_dealer_name in", values, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameNotIn(List<String> values) {
            addCriterion("payee_dealer_name not in", values, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameBetween(String value1, String value2) {
            addCriterion("payee_dealer_name between", value1, value2, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeDealerNameNotBetween(String value1, String value2) {
            addCriterion("payee_dealer_name not between", value1, value2, "payeeDealerName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameIsNull() {
            addCriterion("payee_bank_name is null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameIsNotNull() {
            addCriterion("payee_bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameEqualTo(String value) {
            addCriterion("payee_bank_name =", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotEqualTo(String value) {
            addCriterion("payee_bank_name <>", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameGreaterThan(String value) {
            addCriterion("payee_bank_name >", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("payee_bank_name >=", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameLessThan(String value) {
            addCriterion("payee_bank_name <", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameLessThanOrEqualTo(String value) {
            addCriterion("payee_bank_name <=", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameLike(String value) {
            addCriterion("payee_bank_name like", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotLike(String value) {
            addCriterion("payee_bank_name not like", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameIn(List<String> values) {
            addCriterion("payee_bank_name in", values, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotIn(List<String> values) {
            addCriterion("payee_bank_name not in", values, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameBetween(String value1, String value2) {
            addCriterion("payee_bank_name between", value1, value2, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotBetween(String value1, String value2) {
            addCriterion("payee_bank_name not between", value1, value2, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardIsNull() {
            addCriterion("payee_bank_card is null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardIsNotNull() {
            addCriterion("payee_bank_card is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardEqualTo(String value) {
            addCriterion("payee_bank_card =", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotEqualTo(String value) {
            addCriterion("payee_bank_card <>", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardGreaterThan(String value) {
            addCriterion("payee_bank_card >", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardGreaterThanOrEqualTo(String value) {
            addCriterion("payee_bank_card >=", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardLessThan(String value) {
            addCriterion("payee_bank_card <", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardLessThanOrEqualTo(String value) {
            addCriterion("payee_bank_card <=", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardLike(String value) {
            addCriterion("payee_bank_card like", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotLike(String value) {
            addCriterion("payee_bank_card not like", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardIn(List<String> values) {
            addCriterion("payee_bank_card in", values, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotIn(List<String> values) {
            addCriterion("payee_bank_card not in", values, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardBetween(String value1, String value2) {
            addCriterion("payee_bank_card between", value1, value2, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotBetween(String value1, String value2) {
            addCriterion("payee_bank_card not between", value1, value2, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountIsNull() {
            addCriterion("actual_loaning_amount is null");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountIsNotNull() {
            addCriterion("actual_loaning_amount is not null");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount =", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount <>", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount >", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount >=", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountLessThan(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount <", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount <=", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountLike(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount like", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountNotLike(java.math.BigDecimal value) {
            addCriterion("actual_loaning_amount not like", value, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("actual_loaning_amount in", values, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("actual_loaning_amount not in", values, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("actual_loaning_amount between", value1, value2, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andActualLoaningAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("actual_loaning_amount not between", value1, value2, "actualLoaningAmount");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Long value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Long value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Long value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Long value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(Long value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(Long value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Long> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Long> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Long value1, Long value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNull() {
            addCriterion("is_deleted is null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNotNull() {
            addCriterion("is_deleted is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedEqualTo(Integer value) {
            addCriterion("is_deleted =", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotEqualTo(Integer value) {
            addCriterion("is_deleted <>", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThan(Integer value) {
            addCriterion("is_deleted >", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_deleted >=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThan(Integer value) {
            addCriterion("is_deleted <", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("is_deleted <=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLike(Integer value) {
            addCriterion("is_deleted like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotLike(Integer value) {
            addCriterion("is_deleted not like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIn(List<Integer> values) {
            addCriterion("is_deleted in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotIn(List<Integer> values) {
            addCriterion("is_deleted not in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted not between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table pcl_loan_info
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}